In [18]:
import pandas as pd
import matplotlib.pyplot as plt
# Load the data into a pandas dataframe
df = pd.read_csv("cdc-moderna-covid-19-vaccine-distribution-by-state.csv")
# Group the data by name
grouped = df.groupby("names")
# Calculate the sum of the allocations for each name
allocations_sum = grouped.sum()
# Calculate the mean of the allocations for each name
allocations_mean = grouped.mean()
# Print the sum of 1st dose allocations by name
print("Sum of 1st Dose Allocations by Name")
allocations_sum["_1st_dose_allocations"].plot(kind="bar", title="Sum of 1st Dose Allocations by Name")
plt.show()
C:\Users\adri_\AppData\Local\Temp\ipykernel_3204\126274806.py:11: FutureWarning: The default value of numeric_only in DataFrameGroupBy.sum is deprecated. In a future version, numeric_only will default to False. Either specify numeric_only or select only columns which should be valid for the function. allocations_sum = grouped.sum() C:\Users\adri_\AppData\Local\Temp\ipykernel_3204\126274806.py:14: FutureWarning: The default value of numeric_only in DataFrameGroupBy.mean is deprecated. In a future version, numeric_only will default to False. Either specify numeric_only or select only columns which should be valid for the function. allocations_mean = grouped.mean()
Sum of 1st Dose Allocations by Name
